from django.db import models

# Create your models here.


class Wertevar(models.Model):
    wvteil = models.IntegerField(db_column="WVTEIL", blank=True, null=True)  # Field name made lowercase.
    wvmerkmal = models.SmallIntegerField(db_column="WVMERKMAL", blank=True, null=True)  # Field name made lowercase.
    wvunters = models.SmallIntegerField(db_column="WVUNTERS", blank=True, null=True)  # Field name made lowercase.
    wvwertnr = models.IntegerField(db_column="WVWERTNR", blank=True, null=True)  # Field name made lowercase.
    wvwert = models.FloatField(db_column="WVWERT", blank=True, null=True)  # Field name made lowercase.
    wvattribut = models.SmallIntegerField(db_column="WVATTRIBUT", blank=True, null=True)  # Field name made lowercase.
    wvpruefer = models.IntegerField(db_column="WVPRUEFER", blank=True, null=True)  # Field name made lowercase.
    wvpruefmit = models.IntegerField(db_column="WVPRUEFMIT", blank=True, null=True)  # Field name made lowercase.
    wvmaschine = models.IntegerField(db_column="WVMASCHINE", blank=True, null=True)  # Field name made lowercase.
    wvnest = models.IntegerField(db_column="WVNEST", blank=True, null=True)  # Field name made lowercase.
    wvdatzeit = models.DateTimeField(db_column="WVDATZEIT", blank=True, null=True)  # Field name made lowercase.
    wvstianf = models.SmallIntegerField(db_column="WVSTIANF", blank=True, null=True)  # Field name made lowercase.
    wvcharge = models.CharField(db_column="WVCHARGE", max_length=30, blank=True, null=True)  # Field name made lowercase.
    wvauftrag = models.CharField(db_column="WVAUFTRAG", max_length=20, blank=True, null=True)  # Field name made lowercase.
    wv0005 = models.CharField(db_column="WV0005", max_length=35, blank=True, null=True)  # Field name made lowercase.
    wv0009 = models.CharField(db_column="WV0009", max_length=255, blank=True, null=True)  # Field name made lowercase.
    wv0011 = models.CharField(db_column="WV0011", max_length=255, blank=True, null=True)  # Field name made lowercase.
    wv0014 = models.CharField(db_column="WV0014", max_length=40, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = "WERTEVAR"
        unique_together = (
            ("wvteil", "wvmerkmal", "wvunters", "wvwertnr"),
            ("wvteil", "wvmerkmal", "wvwertnr"),
        )
